Example: SQL Expression

A new dataset will be created, containing the filtered fields which are sorted according to your specifications.

One or more fields are filtered using a WHERE clause, which defines the conditions to be used for filtering. The resulting dataset will only contain these selected fields, with values that meet the stipulated conditions. These fields are sorted by selecting the most important field for investigation, and sorting into ascending or descending order.

Example 1:

Initial dataset:

Configuration:

Selected Fields: Field1, Field2, Field3 and Field4

Filter Entered: WHERE clause: [Row Number] >=1 AND [Row Number] <= 5

No sort order will be entered.

Resulting dataset:

Example 2:

This example will not filter all the fields, and a field will be used for sorting.

Initial :

Configuration:

Selected Fields: Field2, Field3 and Field4

Filter Entered: WHERE clause: [Row Number] >= 5 and [Row Number] <= 10

Sort on: Field 3 descending

Resulting dataset: